select sum(dkb.sume_begin), orgb.showname from dkbase dkb, orgbase orgb where dkb.rn_agent = orgb.rn group by orgb.rn order by orgb.showname

select * from dkspec dks where dks.date_eo > ctod('01.05.2008')               

select count(fa.orbase_rn) c from faceacc fa group by fa.orbase_rn having c>=1 order by c desc                                                          

select fa.orbase_rn,fa.faceacc_rn,o.rmnemo_org,fa.number,tc.c from faceacc fa inner join orgbase o on o.rn=fa.orbase_rn left join temp_count tc on (tc.orbase_rn=fa.orbase_rn) order by c desc,fa.orbase_rn                                          

select count(fa.orbase_rn) c, fa.faceacc_rn, fa.orbase_rn from faceacc fa group by fa.orbase_rn order by c desc

select count(fa.orbase_rn) c, fa.orbase_rn from faceacc fa into cursor temp_count group by fa.orbase_rn order by c desc



*****      *******

select fa.orbase_rn, fa.faceacc_rn, temp_count.c from faceacc fa, temp_count where fa.orbase_rn=temp_count.orbase_rn order by temp_count.c desc
select count(fa.orbase_rn) c, fa.orbase_rn from faceacc fa into cursor temp_count group by fa.orbase_rn order by c desc

**********************************************

********* - faceacc  count>1 **********

select fa.orbase_rn, count(*) from faceacc fa group by fa.orbase_rn HAVING count(fa.faceacc_rn)>1


SELECT d.docs_rn from docs d, goodsdoc gd INTO cursor bills_info WHERE d.type = '2' AND gd.goodsdoc_rn = d.docs_rn AND (gd.pay_sum < d.sum OR gd.pay_sum = 0)

*********      ******************

SELECT a.pf_id, count(*) FROM zank A GROUP BY a.pf_id HAVING count(a.pf_id)>1 INTO CURSOR tmpdbl
SELECT a.orgbase_rn, a.ank_rn, b.surname, b.firstname, b.secondname, c.pf_id FROM zank A, person B, tmpdbl C INTO CURSOR formprint WHERE a.orgbase_rn==b.orbase_rn AND a.pf_id==c.pf_id AND !EMPTY(ALLTRIM(a.pf_id)) ORDER BY surname, firstname, secondname
SELECT FORMPRINT
BROWSE LAST
